<?

//Initiate Authenticate
SecurityRedirect ();

//initiate Vars
define("PRIMARY_KEY","nobkt");
$KEY[]         = array("PRIMARY_KEY"=>PRIMARY_KEY);
$FileName      = "ais_report_cbr.php";
$FileTemplate  = "ais_report_cbr_list.html";
$TableName     = "ais_piutang";
$SubHeaderTitle= "Report - Cash/Bank Report";
$PageSize      = 10;
$HTMLGridList  = "CBReport";

//************ FORM ACTION **************
$periodYear  = GetParam("periodYear","");
$periodMonth = GetParam("periodMonth","");

//******* SHOW FORM CONTENT *********
$TBS = new clsTinyButStrong;
$TBS->LoadTemplate($MOD_TEMPLATE_DIR."/".$FileTemplate);
$TBS->MergeBlock("monthformblk",GetArrayMonth());
$TBS->MergeBlock("yearformblk",GetArrayYear());
$SQLSkada = "SELECT distinct skada, namacc FROM tblcash, tblcoa WHERE tblcash.coa=tblcoa.skada " ;
//$SQLSkada = "SELECT skada, namacc FROM tblcash, tblcoa WHERE tblcash.coa=tblcoa.skada " ;
$TBS->MergeBlock("skadakasblk",$DBMysql,$SQLSkada);

$SQLSkada = "SELECT distinct skada, namacc FROM tblbank, tblcoa WHERE tblbank.coa=tblcoa.skada";
$TBS->MergeBlock("skadabankblk",$DBMysql,$SQLSkada);

$SQLOffice = "SELECT * FROM tblkantor ";
$TBS->MergeBlock("officeformblk",$DBMysql,$SQLOffice);
$TBS->Show();
?>